﻿/* Create GetDatabaseServer Procedure */
/**************************************/
PRINT N'Creating {dbowner}[{dbprofix}GetDatabaseServer]'
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'{dbowner}[{dbprofix}GetDatabaseServer]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
  DROP PROCEDURE {dbowner}[{dbprofix}GetDatabaseServer]
GO

CREATE PROCEDURE {dbowner}[{dbprofix}GetDatabaseServer]
AS
	SELECT ServerProperty('Edition') AS ProductName,
           ServerProperty('ProductVersion') AS Version
GO